FaLoanApplication

Logical Entity Name | FaLoanApplication
Default Table Name | FaLoanApplication
Physical Only | NO
Owner | dbo
Definition |
Note |

FaLoanApplication Columns

ColumnName | Domain | Datatype | NULL | Definition
FaLoanApplicationID |  | int | NO |
SyStudentID |  | int | YES |
FaLoanID |  | int | YES |
ApplicationSubmissionReason |  | char(30) | YES |
UnknownLoanAmount |  | bit | YES |
AwardRangeRequestedStartDate |  | smalldatetime | YES |
AwardRangeRequestedEndDate |  | smalldatetime | YES |
SixMonthDefermentOption |  | bit | YES |
SchoolCreditBalanceOption |  | bit | YES |
PreviousApplicationID |  | char(10) | YES |
UserId |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
ReconsiderationEligible |  | bit | YES |
PLUSCounselingCompleted |  | bit | YES |
PLUSCounselingCompleteDate |  | datetime | YES |
CreditRequirementsMet |  | bit | YES |
EndorserApproved |  | bit | YES |
PLUSCounselingExpirationDate |  | datetime | YES |
CODCommentCodes |  | varchar(100) | YES |

FaLoanApplication Primary and Unique Keys

Key Name | Key Type | Keys
PK_FaLoanApplication_FaLoanApplicationId | PrimaryKey | FaLoanApplicationID
Uk_FaLoanApplication_FaLoanApplicationID_DateLstMod | Index | FaLoanApplicationID, DateLstMod
Uk_FaLoanApplication_FaLoanApplicationID_DateAdded | Index | FaLoanApplicationID, DateAdded
Uk_FaLoanApplication_FaLoanApplicationID_FaLoanID | Index | FaLoanApplicationID, FaLoanID
Uk_FaLoanApplication_FaLoanApplicationID_SyStudentID | Index | FaLoanApplicationID, SyStudentID

FaLoanApplication Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
FaLoan | Non-Identifying | Zero or One to Zero or More | FK_FaLoanApplication_FaLoanID_FaLoan_FaLoanID |  |  | FaLoanID | NO | YES
syStudent | Non-Identifying | Zero or One to Zero or More | FK_FaLoanApplication_SyStudentID_SyStudent_SyStudentID |  |  | SyStudentID | NO | YES
SyStaff | Non-Identifying | One To Zero or More | FK_FaLoanApplication_UserID_SyStaff_SyStaffID |  |  | UserId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

FaLoanApplication Check Constraints

Check Constraint Name | CheckConstraint

FaLoanApplication Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaLoanApplication Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentAwardLoanApplication | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaLoanApplication | NO |  |  |

FaLoanApplication Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaLoanApplication Data Movement Rules

Name | Type | Rule Text/Value